Update years of experience of an employee using schedule function
Here is our approach to update years of experience of an employee using schedule function
Our Assumption
1. We assume that you have a dateofhire (date) field Years of Experience (Number) field in Employee form
2. Also you have enough subscription plan to create Schedule function
Approach
We've given the steps of update years of experience of an employee using schedule
1. Creating new schedule function
1.1 Tap on "Edit this application"
1.2 Go to workflow section
1.3 Tap on "Schedules"
1.4 Tap on "New Workflow"
1.5 Give conditions for schedule function as mentioned in the below image and tap on "Create Function"
1.6 Tap on "Add New Action"
1.7 Tap on "Deluge Script"
1.6 Copy and paste the below code in the Code Snippet and tap on "Save"
Code Snippet
Related Community Question
Auto Update a Date field | Link
I have an employee form where the "Years of Service" date is calculated based on his/her hire date.
yos=dateofhire.days360(zoho.currentdate)/365;
When I view the record, the Years of Service is incorrect.
If I go in and create a new or edit the date of hire, the years of service calculates correctly.
How can I achieve this in the best way?
Schedule update on a Daily schedule?
Create a "OnLoad" event?
